keyPath
:
My Reminders.evergreenLists.[Shortcut Input]
File
:
{ "fileLocation": { "WFFileLocationType": "iCloud", "fileProviderDomainID": "com.apple.CloudDocs.iCloudDriveFileProvider/8CD4A3FB-3479-45CB-829A-CE2FA3119626", "relativeSubpath": "iCloud~md~obsidian/Documents/Second-Brain/EvergreenLists", "appContainerBundleIdentifier": "md.obsidian", "crossDeviceItemID": "docs.icloud.com:com.apple.CloudDocs/70E84BB3-A9B1-4897-8FFA-8765BB8D22AD/081372c23c296cb9dad621c423628c7356f39415" }, "filename": "EvergreenLists", "displayName": "EvergreenLists" }
Input
:
[2 spreadsheetId]
Workflow
:
{ "workflowIdentifier": "61660668-ECB6-4317-9357-F1500B482984", "workflowName": "Cleanup Spreadsheet", "isSelf": false }
{ "spreadsheetId": "[2 spreadsheetId]", "spreadsheetTitle": "[Shortcut Input]" }
Input
:
[4 Dictionary]
Workflow
:
{ "workflowIdentifier": "5C0590A5-318A-4245-8C14-CCE0341C9153", "workflowName": "Set Spreadsheet Title", "isSelf": false }
Folder
:
[1 EvergreenLists]
Folder
:
[6 Created Folder]
ContentItemLimitEnabled
:
true
ContentItemLimitNumber
:
1
ContentItemFilter
:
File Extension is gsheet
ContentItemLimitEnabled
:
false
ContentItemLimitNumber
:
1
ContentItemFilter
:
• All the following are true List is [Shortcut Input] Is Completed
Input
:
[Repeat Item]
Workflow
:
{ "workflowIdentifier": "01C66C6E-825F-4ABF-90D6-56541924A04C", "workflowName": "Sanity Check JSON String", "isSelf": false }
{ "spreadsheetId": "[2 spreadsheetId]", "newSheetName": "[13 newSheetName]" }
Input
:
[14 Dictionary]
Workflow
:
{ "workflowIdentifier": "D3140BE4-B4BE-4B36-BF27-85CE89C76715", "workflowName": "Add Sheet", "isSelf": false }
{ "requests": [ { "updateCells": { "rows": [ { "values": [ { "userEnteredValue": { "stringValue": "[0 Value as Dictionary.headerTitle]" } }, { "userEnteredValue": { "stringValue": "Note" } } ] } ], "fields": "userEnteredValue", "range": { "sheetId": "[16 sheetId]", "startRowIndex": 0, "endRowIndex": 1, "startColumnIndex": 0, "endColumnIndex": 2 } } }, { "repeatCell": { "range": { "sheetId": "[16 sheetId]", "startRowIndex": 0, "endRowIndex": 1, "startColumnIndex": 0, "endColumnIndex": 2 }, "cell": { "userEnteredFormat": { "backgroundColor": { "red": 0.0, "green": 0.0, "blue": 0.0 }, "horizontalAlignment": "CENTER", "textFormat": { "foregroundColor": { "red": 1.0, "green": 1.0, "blue": 1.0 }, "fontSize": 12, "bold": true } } }, "fields": "userEnteredFormat(backgroundColor,textFormat,horizontalAlignment)" } }, { "updateSheetProperties": { "properties": { "sheetId": "[16 sheetId]", "gridProperties": { "frozenRowCount": 1 } }, "fields": "gridProperties.frozenRowCount" } }, { "updateDimensionProperties": { "range": { "sheetId": "[16 sheetId]", "dimension": "COLUMNS", "startIndex": 0, "endIndex": 1 }, "properties": { "pixelSize": 450 }, "fields": "pixelSize" } }, { "updateDimensionProperties": { "range": { "sheetId": "[16 sheetId]", "dimension": "COLUMNS", "startIndex": 1, "endIndex": 2 }, "properties": { "pixelSize": 300 }, "fields": "pixelSize" } } ] }
{ "spreadsheetId": "[2 spreadsheetId]", "requestBody": "[17 Text]" }
Input
:
[18 Dictionary]
Workflow
:
{ "workflowIdentifier": "62665609-710F-4ADF-B59D-D4B62A9348EE", "workflowName": "Batch Update Cells", "isSelf": false }
Input
:
[21 Title]
Workflow
:
{ "workflowIdentifier": "DAB244B1-0299-4B66-A0F1-726F17ED5A84", "workflowName": "Get Plain Text from Markdown", "isSelf": false }
Input
:
[22 Shortcut Result]
Workflow
:
{ "workflowIdentifier": "01C66C6E-825F-4ABF-90D6-56541924A04C", "workflowName": "Sanity Check JSON String", "isSelf": false }
"formulaValue": "=HYPERLINK(\"[Repeat Item 2’s URL]\", \"[25 Updated Text]\")"
"stringValue": "[23 Shortcut Result]"
Input
:
[31 Notes]
Workflow
:
{ "workflowIdentifier": "DAB244B1-0299-4B66-A0F1-726F17ED5A84", "workflowName": "Get Plain Text from Markdown", "isSelf": false }
Input
:
[32 Shortcut Result]
Workflow
:
{ "workflowIdentifier": "01C66C6E-825F-4ABF-90D6-56541924A04C", "workflowName": "Sanity Check JSON String", "isSelf": false }
"stringValue": "[33 Shortcut Result]"
"stringValue": ""
{ "updateCells": { "rows": [ { "values": [ { "userEnteredValue": { [29 If Result] }, "userEnteredFormat": { "wrapStrategy": "WRAP" } }, { "userEnteredValue": { [37 If Result] }, "userEnteredFormat": { "wrapStrategy": "WRAP" } } ] } ], "fields": "userEnteredValue,userEnteredFormat.wrapStrategy", "range": { "sheetId": "[16 sheetId]", "startRowIndex": [Repeat Index 2], } } }\u{space}\u{space}
TextCustomSeparator
:
,
{ "spreadsheetId": "[2 spreadsheetId]", "requestBody": "{\"requests\": [[40 Combined Text]]}" }
Input
:
[41 Dictionary]
Workflow
:
{ "workflowIdentifier": "62665609-710F-4ADF-B59D-D4B62A9348EE", "workflowName": "Batch Update Cells", "isSelf": false }
Clear and hide the default "Sheet1" (as it cannot be deleted…)
Input
:
[2 spreadsheetId]
Workflow
:
{ "workflowIdentifier": "0D603809-4C0E-4AAC-BD7F-130E53B7D50B", "workflowName": "Get Spreadsheet", "isSelf": false }
{ "spreadsheetId": "[2 spreadsheetId]", "sheetName": "[48 sheetName]" }
Input
:
[49 Dictionary]
Workflow
:
{ "workflowIdentifier": "95C98501-4C91-4050-998A-26AD227924DE", "workflowName": "GSheets - Clear Sheet", "isSelf": false }
{ "spreadsheetId": "[2 spreadsheetId]", "sheetId": "[51 sheetId]" }
Input
:
[52 Dictionary]
Workflow
:
{ "workflowIdentifier": "7C0251C3-9077-44A9-A610-E68A5F68CFB3", "workflowName": "Hide Sheet", "isSelf": false }